package com.ynet.middleground.contract.dao;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ynet.middleground.contract.entity.ArchiveOperationLog;

/**
 * <p>
 * 档案统计表 Mapper 接口
 * </p>
 *
 * @author daigaole
 * @since 2020-04-07
 */
public interface ArchiveOperationLogMapper extends BaseMapper<ArchiveOperationLog> {

    @Select({"select count(*) from ct_template_operation_log "
        + "where operation_type = #{operationType} and channel = #{channel} " + "and template_type = #{templateType} "})
    Integer statisticalNumber(@Param("templateType") String templateType, @Param("operationType") String operationType,
        @Param("channel") String channel);

}
